/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-25 10:32:28
*/


-- ----------------------------
-- Table structure for tb0075
-- ----------------------------
DROP TABLE [dbo].[tb0075]
GO
CREATE TABLE [dbo].[tb0075] (
[DivisionID] varchar(20) NOT NULL ,
[ModuleID] varchar(20) NOT NULL ,
[GroupID] varchar(20) NOT NULL ,
[DataID] varchar(20) NOT NULL ,
[DataType] char(2) NOT NULL DEFAULT ('PE') ,
[BeginChar] nvarchar(100) NULL ,
[Permission] bit NOT NULL DEFAULT ((1)) ,
[CreateDate] datetime NULL ,
[CreateUserID] varchar(20) NULL ,
[LastModifyUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL 
)


GO

-- ----------------------------
-- Indexes structure for table tb0075
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0075
-- ----------------------------
ALTER TABLE [dbo].[tb0075] ADD PRIMARY KEY ([DivisionID], [ModuleID], [GroupID], [DataID], [DataType])
GO




